During the merge process, the records in the following tables are deleted if any of the fields listed contain the value of any ID from the IDs to Delete list.
|
Table |
Field(s) |
|
Cert_Register |
ID, STUDENT_ID |
|
Invoice |
BT_ID |
|
Invoice_Lines |
Invoice.BT_ID |
|
Meet_Hotel |
ID |
|
Meet_Master |
CONTACT_ID |
|
Name |
ID |
|
Name_Log |
ID |
|
Orders |
BT_ID |
|
Ref_Client |
CLIENT_ID |
|
Ref_Provider |
PROVIDER_ID |
|
Referral |
CLIENT_ID, PROVIDER_ID |
|
Relationship |
ID, TARGET_ID |
|
Subscriptions |
ID |
|
Trans |
BT_ID |
|
Name_Address |
ID |
|
Name_Fin |
ID |
|
Name_FR |
ID |
|
Name_Indexes |
ID |
|
Name_Note |
ID |
|
Name_Picture |
ID |
|
Name_Security |
ID |
|
Name_Security_Groups |
ID |
|
Name_Staff |
ID |
Note: If an Invoice.BT_ID is equal to a Delete ID and the Invoice.REFERENCE_NUM is equal to the Invoice_Lines.REFERENCE_NUM, the Invoice_Lines record is deleted along with the Invoice record.
The following fields are updated to empty if they contain the value of any ID from the IDs to Delete list:
|
Table |
Field(s) |
|
Activity |
ID, CO_ID, OTHER_ID, SOLICITOR_ID |
|
Cert_Register |
BT_ID |
|
Invoice |
ST_ID |
|
Invoice_Lines |
ST_ID |
|
Name |
CO_ID, BT_ID |
|
Name_FR |
SOLICITOR_ID |
|
Orders |
ST_ID, CO_ID |
|
Subscriptions |
BT_ID |
|
Trans |
ST_ID, SOLICITOR_ID |
|
User-defined tables |
All records for the Delete ID are deleted |